TaskArchive

EntityType | Independent
Logical Entity Name | TaskArchive
Default Table Name | CmEventHistory_ro
Logical Only | NO
Owner | dbo
Definition |
Note |

TaskArchive Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
TaskStartDate |  | DATETIME | YES |
TaskEndDate |  | DATETIME | YES |
RemindDate |  | DATETIME | YES |
TaskDueDate |  | DATETIME | YES |
Note |  | TEXT | NO |
Subject |  | VARCHAR(255) | YES |
Priority |  | CHAR(10) | NO |
TaskTemplateId |  | INTEGER | NO |
TaskTypeId |  | INTEGER | NO |
TaskStatusId |  | INTEGER | NO |
TaskStatusDate |  | DATETIME | YES |
TaskResultId |  | INTEGER | NO |
SourceRecordID |  | INTEGER | NO |
SourceTable |  | CHAR(20) | NO |
ResultText |  | VARCHAR(255) | YES |
CreatedByStaffId |  | INTEGER | NO |
CompletedByStaffId |  | INTEGER | NO |
TemplateTextFile |  | VARCHAR(50) | NO |
UserID |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
DateLstMod |  | DATETIME | NO |
ModFlag |  | CHAR(1) | NO |
ts |  | TIMESTAMP/DATE | NO |
TaskArchiveId |  | INTEGER | NO |
EmployerId |  | INTEGER | YES |
StaffId |  | INTEGER | YES |
StudentId |  | INTEGER | YES |
ProspectInquiryId |  | INTEGER | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |
EmployerJobId |  | INTEGER | YES |
SyOrganizationID |  | INTEGER | YES |
SyOrganizationContactID |  | INTEGER | YES |
EmailSubject |  | VARCHAR(255) | YES |
PreviouslyAssignedToStaffId |  | INTEGER | YES |
Attachments |  | VARCHAR(1280) | YES |
EmployerContactId |  | INTEGER | YES |
IsExcludedCrmIntegration |  | BIT | NO |
AttachmentId |  | INTEGER | YES |
SourceSystem |  | CHAR(1) | NO |
SessionSyCampusID |  | INTEGER | YES |
IsActivityNotViewed |  | BIT | NO |
ReassignedDate |  | DATETIME | YES |
WorkflowInstanceIdentifier |  | UNIQUEID | YES |
PlEmployerJobID |  | INTEGER | YES |
TaskTypeId |  | INTEGER | YES |

TaskArchive Keys

Key Name | Key Type | Keys
CmEventHistory_ro_CmTemplateID_N_N_IDX | Inversion Entry | TaskTemplateId
CmEventHistory_ro_CmEventID_U_C_IDX | PrimaryKey | TaskArchiveId
NK_CmEventHistory_roPlEmployerContactID | Inversion Entry | EmployerContactId
NK_CmEventHistory_roPrevSyStaffID | Inversion Entry | PreviouslyAssignedToStaffId
CmEventHistory_ro_SyOrganizationContactID_N_N_IDX | Inversion Entry | SyOrganizationContactID
CmEventHistory_ro_SyOrganizationID_N_N_IDX | Inversion Entry | SyOrganizationID
CmEventHistory_ro_SetupBy_N_N_IDX | Inversion Entry | CreatedByStaffId
CmEventHistory_ro_CmEventResultID_N_N_IDX | Inversion Entry | TaskResultId
CmEventHistory_ro_CmTemplateID_CmEventStatusID_DueDate_N_N_IDX | Inversion Entry | TaskTemplateId, TaskStatusId, TaskDueDate
CmEventHistory_ro_DueDate_N_N_IDX | Inversion Entry | TaskDueDate
CmEventHistory_ro_CmEventTypeID_N_N_IDX | Inversion Entry | TaskTypeId
CmEventHistory_ro_CmEventStatusID_N_N_IDX | Inversion Entry | TaskStatusId
NK_CmEventHistory_roSessionSyCampusID | Inversion Entry | SessionSyCampusID
NK_CmEventHistory_roCmAttachmentsId | Inversion Entry | AttachmentId
CmEventHistory_ro_CmEventStatusID_DueDate_N_N_IDX | Inversion Entry | TaskStatusId, TaskDueDate
CmEventHistory_ro_CmTemplateID_CmEventStatusID_DueDate_SyStudentID_PlEmployerID_N_N_IDX | Inversion Entry | TaskTemplateId, TaskStatusId, TaskDueDate
CmEventHistory_ro_SyStaffID_N_N_IDX | Inversion Entry | StaffId

TaskArchive Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffId | NO
Attachment | Non-Identifying | Zero or One to Zero or More |  |  |  | AttachmentId | NO
EmployerContact | Non-Identifying | Zero or One to Zero or More |  |  |  | EmployerContactId | NO
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | SessionSyCampusID | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffId | NO
Employer | Non-Identifying | Zero or One to Zero or More |  |  |  | EmployerId | NO
EmployerJob | Non-Identifying | Zero or One to Zero or More |  |  |  | PlEmployerJobID | NO
TaskResult | Non-Identifying | One To Zero or More |  |  |  | TaskResultId | NO
TaskStatus | Non-Identifying | One To Zero or More |  |  |  | TaskStatusId | NO
TaskType | Non-Identifying | One To Zero or More |  |  |  | TaskTypeId | NO
TaskTemplate | Non-Identifying | One To Zero or More |  |  |  | TaskTemplateId | NO
SyOrganizationContact | Non-Identifying | Zero or One to Zero or More |  |  |  | SyOrganizationContactID | NO
SyOrganization | Non-Identifying | Zero or One to Zero or More |  |  |  | SyOrganizationID | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | PreviouslyAssignedToStaffId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffId | NO
ProspectInquiry | Non-Identifying | Zero or One to Zero or More |  |  |  | ProspectInquiryId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
SyOrganization | Non-Identifying | Zero or One to Zero or More |  |  |  | SyOrganizationID | NO
SyOrganizationContact | Non-Identifying | Zero or One to Zero or More |  |  |  | SyOrganizationContactID | NO
TaskResult | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskResultId | NO
TaskStatus | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskStatusId | NO
TaskTemplate | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskTemplateId | NO
TaskType | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskTypeId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

TaskArchive Check Constraints

Check Constraint Name | CheckConstraint

TaskArchive Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.TaskArchive | NO |  |  |
Physical (Microsoft SQL Server) dbo.CmEventHistory_ro | NO |  |  |

TaskArchive Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Tasks
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Career Services

TaskArchive Data Movement Rules

Name | Type | Rule Text/Value